CREATE VIEW [dbo].[vSoaPartyCommercePreferences]
AS
SELECT [Name].[ID] AS [PartyCommercePreferencesId], [Name].[ID] as [PartyId],
  (SELECT CONVERT(NVARCHAR(10),[ParameterValue]) FROM [SystemConfig] WHERE [ParameterName] = 'DefaultCurrencyCode' AND [SystemEntityKey] = '74E640E8-538D-438E-BBFD-AC48460B4758') AS [DefaultCurrencyCode],
  CASE WHEN [Name].[MEMBER_RECORD] = 1 THEN 'Member'
      ELSE 'Standard'
  END AS [PriceSheetName],
    CASE WHEN [Name].[MEMBER_RECORD] = 1 THEN 'Member pricing'
      ELSE 'Non-Member pricing'
  END AS [PriceSheetDescription]

FROM [Name];

GO